ADO - metadata properties

Otázka od: Miso

23. 11. 2004 11:55

Zdar,

..mozete sa niekto podelit o prakticke skusenosti s pouzitim
%subj.%...konkretne ma zaujima pouzitie [BASETABLENAME] a [BASECOLUMNAME]..
na MSDN som nasiel, ze :

".. obtaining BaseTableName is an expensive operation, is only supported for
serverside recordsets, and is not supported by all providers. "

..v tejto suvislosti som teda pouzil :

rs := CoRecordset.Create; // ADODB_TLB; Recordset15
rs.CursorLocation := adUseServer;
rs.Open(Query, Connection, adOpenDynamic, adLockReadOnly, adCmdText);

..v pripade, ze Query je nejaky jednoduchy dotaz typu "select * from xxx",
tak je vsetko ok, pre dane stlpce v pohode zistim metadata
properties...avsak ak Query je napr.
"select * from (select top 100 * from
(select * from xxx)as TableXXX) as TableYYY where cond1 or cond2 or ...or
cond60 order by fld1 DESC, fld2 ASC ",
tak tieto metadata properties su
prazdne..nejake napady ako ziskat tieto metadata properites?

Dik,
Miso